Hire
Effective Date | To Date | Notes |
---|---|---|
01/05/2014 | 30/09/2014 | - To Date is not editable, and is maintained by the system. - To Date is the day prior to the next effective date record (From). - Records are continuous. No gaps allowed. - End Date of last record is always a system defined date in the future (31/12/9999). |
01/10/2014 | 14/10/2014 | |
15/10/2014 | 30/11/2014 | |
01/12/2014 | 31/12/9999 |
Transfer
An employee has the following effective dated records as of the current date '03/12/2015'.
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
01/01/2016 | 29/02/2016 | Extreme Electronics |
01/03/2016 | 31/12/9999 | Extreme Electronics |
Employee ID 000777: Version '0', Status 'R'
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
Employee ID 000777: Status 'A'
From | To | Company |
---|---|---|
01/12/2014 | 31/12/9999 | North Pole Enterprises |
When an employee is transferred from one company to another and a Salary Package record exists with a Package Status Confirmed at the time of the transfer, it will be end dated using 'Transfer Date - 1 day'. The new version of the employee will have a copy of the end dated package assigned to the employee using From date = 'Transfer date' and To date = '31/12/9999', only if during the review process on the Company Transfers wizard's Review screen, the Packaged Employee check box has been left as ticked.
Whenever an employee is transferred from one Position to another and a Salary Package record exists with a Package Status Confirmed, this will be end dated using 'Position Transfer Date - 1 day'.
If the employee is currently assigned with a Confirmed Salary Package at the time the new Position record is to become effective, the new Position has Payroll defaults attached to it and are to be applied, and Create Salary Package flag value = 'Y', then:
If the employee is assigned with a Salary Package, and the Create Salary Package flag is set to a value different from 'Y' ('N' or blank) then:
If the employee has not been assigned with a Salary Package and the Create Salary Package flag is set to 'Y', then the flag is ignored and the defaults are processed over the employee as if a package has never existed for the employee.
Termination
Employee ID 000777 has the following effective dated record as of Today's date '03/12/2015'.
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 29/02/2016 | Extreme Electronics |
01/03/2016 | 31/12/9999 | Extreme Electronics |
The employee will be terminated on '31/12'2015'.
As part of the Termination process, the employee record will be updated as follows:
Employee ID: 000777; Status: T
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
Employee Termination Date = '31/12/2015'
The employee has the following effective dated records for Meal Allowance A/D Code:
From | To |
---|---|
01/07/2014 | 15/09/2014 |
30/06/2015 | 23/09/2015 |
1/12/2015 | 03/03/2016 |
07/08/2016 | 31/12/2016 |
After completing the termination, the effective dated records for the employee with a Status of 'T' is:
From | To |
---|---|
01/07/2014 | 15/09/2014 |
30/06/2015 | 23/09/2015 |
1/12/2015 | 31/12/2016 |
Using the same records of the example employee above in the Terminate Process section (Employee ID - 000777):
The employee will be terminated using the Termination Wizard with a Termination Date of '31/12/2015' (Paid up to Date = 30/12/2015). Once the Wizard is completed, the user performing the Termination will go to Release Other Payments, set the status to 'R', then go to Process All Payments.
As part of the Termination Process, the employee record will be updated to:
Employee ID: 000777; Status: T
This happens after the Process All Payments has been completed.
The current effective record will be updated to have To date = Termination Date.
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
Using the same records of the example employee above in the Terminate Process section (Employee ID - 000777):
The employee will be terminated using the Termination Wizard with a Termination Date of '31/12/2015' (Paid up to Date = 30/12/2015). Once the Wizard is completed, the user performing the Termination will go to Release Other Payments, set the status to 'E', then go to Process All Payments.
At this stage, the employee is still Active. If required to be cancelled, the employee will already be available in the list of Termination Transactions allowed to be cancelled.
Once Payrun is processed as part of the Update Payrun step, the employee record status is changed to 'T'. If checking at the employee details on the Costing screen, the record will be:
Employee ID: 000777; Status: T (Effective Dated records have not been cleaned up.)
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 29/02/2016 | Extreme Electronics |
01/03/2016 | 31/12/9999 | Extreme Electronics |
As part of the Payrun Close, the effective dated records will be updated to:
Employee ID: 000777; Status: T (Effective Dated records have been cleaned up.)
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
In case the status is changed to 'R' or 'D', once the Release Express Payments process is run, the employee record will be set to have a status of 'T' and all effective dated records will be cleaned up. Thus, the current record will be updated with To date = Termination Date, and all future effective dated records will be deleted.
If the Payrun is reset, the employee status will be set back to 'A', and all effective dated records will be restored.
Default Start and End Dates for Effective Dated Employee Mappers: The handling of effective dating updates for Terminated employee (T) whose Effective Start or End Dates are not provided in the import file has been adjusted for all Effective Dated Employee Mappers. When an effective dated mapper is used without any effective dates, the logic is:
If the Paid Up To Date is invalid/ null, Effective Start Date = Hire Date/ Transfer Date.
Reactivation
Having terminated the employee ID 000777, the Status is 'T' on '31/12/2015'.
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
After running the reactivation process, the Costing records are refreshed as follows:
Employee ID 000777: Status 'A'
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/9999 | Extreme Electronics |
Reinstate
If an employee is rehired, and Reinstate is used to keep the employee's original details, the following behavior is expected in Costing as part of the Reinstate:
If the future effective dated records existed at the moment of the termination, those will NOT be recovered. Any future dated changes are to be added again.
Having terminated Employee ID 000777, the Status is now 'T' on 31/12/2015.
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
The effective date of Reinstate is on 01/02/2016.
After running the Reinstate Process, the employee is affected as follows:
Employee ID 000777: Version '0', Status 'R'
From | To | Company |
---|---|---|
01/07/2014 | 30/09/2014 | Extreme Electronics |
01/10/2014 | 14/10/2014 | Extreme Electronics |
15/10/2014 | 30/11/2014 | Extreme Electronics |
01/12/2014 | 31/12/2015 | Extreme Electronics |
Employee ID 000777: Status 'A'
From | To | Company |
---|---|---|
01/12/2014 | 31/12/9999 | Extreme Electronics |
The existing Toolbar in Preceda has been extended to accommodate the Effective Dating capabilities.
Toolbar Option | Action |
---|---|
New |
This makes the fields editable within the form with no values. This is available only for Non-Mandatory model screens. |
Delete |
This enables you to delete an existing effective dated record upon confirmation. Records that correspond to the first occurrence of a set of Mandatory records are not allowed to be deleted. In some scenarios where the employee has been paid against existing records, the records will not be allowed to be deleted either. |
Change | This makes the fields within the form editable with values currently being displayed on screen. Change caters for record edits in Non-Mandatory model screens and for record insertion or edits in Mandatory model screens. |
Cancel | This cancels the changes being performed on an existing effective dated record or the new record you are intending to create. |
<< | This allows you to navigate to prior effective dated records. |
Effective Date |
This is a drop-down list that, by default, displays the record currently effective. This provides you with a list of all the existing records with From and To dates in the format (dd/mm/yyyy - dd/mm/yyyy). Hovering over this option displays the From and To dates as well as the Change Reason within a Tool-tip. |
>> | This allows you to navigate to future effective dated records. |
Editing or adding an effective dated record provides you with a second level Toolbar where the From date and a Change Reason can be defined. A To date field is also available, but its input capability is subject to the record model applicable to the screen you are on.
When you click Change, the screen moves to Edit-mode enabling you to enter and save your changes. When you click Save, the changes are saved based on the data entry.
Please note that the From and To Date Picker Calendar will also have the dates where a record is effective being underlined . Hovering over the underlined dates displays the corresponding From and To dates as well as the Change Reason. Vertical bards are also placed indicating the start and end of the effective dated record.
Effective dating in the mandatory record model means that there is the requirement to have at least one record throughout the employee life cycle (e.g. Costing records) and is enforced that whenever there is more than one effective dated records, there will be no gaps between them.
Terminating employee: If at the time of termination the employee record has no saved changes, then there will be only one record expected to have an Effective Date: Hire Date and Termination Date (which will become the To date).
For an Active employee: The To date where only a single record exists is set to infinity (31/12/9999). If there are several records through the employee life cycle, then the last record will always be defaulted to have To date = '31/12/9999'.
Reference Table screen: Similar rules apply to reference table screens that have been effective dated as mandatory records model. Given the fact that a reference table does not depend on a specific employee life cycle, the From and To dates of effective dated records in a reference table can be defined as desired as long as there are no gaps in between effective dated records.
Adding New Record: To add a new effective dated record, click Change as it will always attempt to insert a new record where the selected From date has not been assigned previously to another effective dated record of the set. Otherwise, it will warn you that there is already an effective dated record and you are expected to determine if the existing record will be overridden by the changes entered or not.
Under this model the To date is not allowed to be changed when creating or editing a record, and if there are no additional records after the one being inserted the, To date will always default to 'Next record From date - 1' or infinity '31/12/9999'.
Effective dating with a non-mandatory record model means that there is no need to have a record since the employee Hire Date (e.g. Allowance codes, Salary Package). In this model, it is also possible define a To date for any effective dated record added.
Using New and Clone: The use of New and Clone is allowed when creating a new non-mandatory effective dated record, as the use of Change is restricted to cater for existing effective dated records editing.
Editing Existing Record: Editing an existing record is changing either the values in the form displayed on screen or the date ranges the record is to be effective on. Overlapping rules apply to Non-Mandatory records as the dates are never defaulted to fit the gaps existing in between records.
A non-mandatory effective dated record can exist from any point in time starting from or after the employee Hire date and until infinity (31/12/9999).
Termination/ Transfer: On Termination or Transfer, only the records that are effective beyond the termination date or until infinity will be modified to be end date with To date = Termination Date.
Samples
The information on an employee screen (i.e. Costing screen) corresponds to the values entered as part of the employee Hire, and will be displayed as read-only. In case there is more than one existing effective dated record, the current effective record is displayed (Effective Dating).
To create a new record, click Change, and the second level Toolbar will be displayed with the From date field automatically populated with today's date and the To date field with '31/12/9999' displayed as read-only (Effective Dating 1).
You may create a new future effective record by modifying the date in the From date picker to a date in the future, and changing the information in the form (Effective Dating 2).
It is not possible to create a new effective dated record prior to the employee Hire Date.
It is possible to work on a current effective dated record when creating a new effective record.
Effective Date | Company | State | Region | Division | Pay Point | Department | Account |
---|---|---|---|---|---|---|---|
01/07/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
Effective Date | % | Department | Account |
---|---|---|---|
01/10/2014 | 40 | Business Development | Business Development |
01/10/2014 | 60 | Business Development | Pre-Sales |
Effective Date | % | Department | Account |
---|---|---|---|
01/12/2014 | 0 | Business Development | Business Development |
01/12/2014 | 0 | Business Development | Pre-Sales |
To edit an effective dated record, such as on the Costing screen:
There is a need to change the State and Region from the record made effective on 01/10/2014.
Effective Date | Company | State | Region | Division | Pay Point | Department | Account |
---|---|---|---|---|---|---|---|
01/07/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
01/10/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development |
BD - 40% Pre-Sales - 60% |
01/12/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
The record immediately displayed is the record with the current effective date which, on this example, is 01/12/2014.
The table below hold the current information for an employee.
Effective Date | Company | State | Region | Division | Pay Point | Department | Account |
---|---|---|---|---|---|---|---|
01/07/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
01/10/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development |
BD - 40% Pre-Sales - 60% |
01/12/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
The following changes need to apply to the table:
Records are to be created in the above-mentioned order.
Following the two changes, the below table is now the updated effective dated records.
Effective Date | Company | State | Region | Division | Pay Point | Department | Account |
---|---|---|---|---|---|---|---|
01/07/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
01/10/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development |
BD - 40% Pre-Sales - 60% |
01/12/2014 | Extreme Electronics | Victoria | Chatswood | Sales | Software | Business Development | Business Development |
01/01/206 | Extreme Electronics | Victoria | (Set to Blank) | Sales | Software | Business Development | Business Development |
01/03/2016 | Extreme Electronics | Victoria | Sales | Software | Administration | Administration VIC |
Note:
When inserting new records between existing future effective dated records, any updates on these records/ changes may affect other changes to be applied in future dates. As a warning, a confirmation message is presented upon Save.
Deleting effective dated records is possible, depending on whether having a record on the screen is mandatory or not. Every deletion of effective dated record requires a user confirmation upon clicking the Delete button.
For previous versions of employee record:
Please complete the form below to give us feedback. If you need any assistance with this functionality, please contact Preceda Support.
|
|
Version 15.3.01 Preceda Knowledge Base
For feedback and comments, please contact your Systems Administrator or Account Manager. |
![]() |
||
![]() |